SET IDENTITY_INSERT [dbo].[store] ON;

Select * from store where store_id = 304;
if @@ROWCOUNT =0
BEGIN
INSERT INTO store ( Store_ID, Description, CompanyName, TradingAs, Address, ContactNo, VATRegNo, 
RegNo, StoreEmailAddress
) VALUES ('304', 'Cash Crusaders The Mutual','Cash Crusaders Durbanville (Pty) Ltd','Cash Crusaders The Mutual','Shop No B05, St Georges Mall,Cape Town','TBA','4760284762','2018/300501/07','TBA');
 END
ELSE
 BEGIN
UPDATE Store set Description = 'Cash Crusaders The Mutual',CompanyName = 'Cash Crusaders Durbanville (Pty) Ltd', TradingAs = 'Cash Crusaders The Mutual', Address='Shop No B05, St Georges Mall,Cape Town', ContactNo = 'TBA', VATRegNo = '4760284762',RegNo = '2018/300501/07', StoreEmailAddress = 'TBA' where Store_ID = 304
 END


 SET IDENTITY_INSERT [dbo].[store] off